<html>
<body>
<a href="Admin_A_Magazine.php"><input type="button" name="Add" value="ADD Magazine"></a>
<table border=2>
<tr>
<th>Magazine_name</th>
<th>Magazine_publish_date</th>
<th>Add photo</th>
<th>Delete photo</th>
<th>Edit pdf URL</th>
<th>Delete Magazine</th>
</tr>
<?php
require ("connection.php");
$my_query = "select * from Magazine";
$cmd = mysql_query($my_query, $connection);
while ($row = mysql_fetch_array($cmd)) {
    $Magid = $row['Magazine_id'];
    echo "<tr>";
    echo "<td>" . $row['Magazine_name'] . "</td>";
    echo "<td>" . $row['Magazine_ptime'] . "</td>";
    echo "<td>" . "<a href='Admin_A_photo.php?x=$Magid'><input type='button' value='ADD photo'></a>" .
        "</td>";
    echo "<td>" . "<a href='A_D_Mphoto.php?x=$Magid'><input type='button' value='Delete photo'></a>" .
        "</td>";
    echo "<td>" . "<a href='Admin_E_pdf.php?x=$Magid'><input type='button' value='Edit pdf URL'></a>" .
        "</td>";
    echo "<td>" . "<a href='A_D_Magazine.php?x=$Magid'><input type='button' value='Delete Magazine'></a>" .
        "</td>";
    echo "</tr>";
}
?>
</table>
</body>
</html>